2016-07-12 - 27629 - Spec - Datasource report for roc and b2b orders #CrystalReportDevelopment
SPECIFICATIONS
27629 - Datasource report for ROC and B2B orders
Requirement Summary
Need to create data source report for ROC and B2B orders.
Admin Info
Purpose
|
Need to create data source report for ROC and B2B orders.
|
Requested By
|
Bibin Mohan
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
07-12-2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ROC011
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
16
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
00
|
|
TOTAL
|
48
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Instead of past 5 days, run report from the beginning of the year.
|
Saravanan
|
07-18-2016
|
Email
|
2
|
Currently the report is accepting input parameters thru date range. Remove that and add "current date - 90".
|
Saravanan
|
07-21-2016
|
Email
|
3
|
vbak.erdat should be between current date and current date -90.
|
Saravanan
|
07-26-2016
|
IM
|
Functional Requirement
Purpose/WHY:
Need to create datasource report for ROC and B2B orders.
In Scope:
Need to create datasource report with required fields in ECC as required.
Out of Scope:
Some of the fields are not available.
Solution Summary
1. Need to create the report with available fields in ECC source.
2. Need to apply the groupings for removing duplicate records in the report.
3. Need to write the filter conditions to get the data for ROC and B2B orders.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create the report with required fields as below:
,[Sales_Organization]
|
VBAK.VKORG
|
,[Cust_ID]
|
VBAK.KUNNR
|
,[Cust_Desc]
|
KNA1.NAME1
|
ROC Order number
|
VBAK.BNAME
|
Internet_Ord_Num] -roc order number
|
VBAK.VBELN
|
,[Inv_Item_ID]material number
|
VBAP.MATNR
|
,[Item_Desc] material description
|
MAKT.MAKTX
|
,[GRID_ID]
|
MARA.J_3APGNR
|
,[Size]
|
VBEP.J_3ASIZE
|
,[Seasona]
|
VBAP.J_3ASEAN
|
,[Collection]
|
VBAP./AFS/COLLECTION
|
,[PONumber]
|
VBAK.BSTNK
|
,[Cust_ID_To] ship to
|
KNA1.KUNNR
|
,[Cust_ID_To_Desc]ship to desc
|
KNA1.NAME1
|
,[Sales_Person]
|
VBAK.VKGRP
|
,[SaleOrderDt] so creation date
|
VBAK.ERDAT
|
,[ShipBydate] delivery date
|
VBAK.VDATU
|
,[CancelDate]
|
VBAP.J_3ACADA
|
,[ShipDate]
|
LIKP.WADAT_IST
|
,[Distribution_Channel]
|
VBAK.VTWEG
|
,[Division]
|
VBAK.SPART
|
,[Team_Desc]
|
Not Available
|
,[Terms_Code]
|
VBKD.ZTERM
|
,[Terms_Desc]
|
TVZBT.VTEXT
|
,[CarrierService] usps / fed ex
|
VBAK.KVGR2
|
,[Carrier_Desc]
|
TVV2T.BEZEI
|
,[CustGroupID]
|
VBKD.KDGRP
|
,[CustGroup_Desc]
|
T151T.KTEXT
|
,[TermsOverride]
|
Not Available
|
,[DealerOverride]
|
Not Available
|
,[ContactPhone]
|
KNA1.TELF1
|
,[ContactFax]
|
KNA1.TELFX
|
,[ContactEmail]
|
ADR6.SMTP_ADDR
|
,[Ctrl_Term]
|
Not Available
|
,[Ctrl_Dealer]
|
Not Available
|
,[Ctrl_Ship]
|
Not Available
|
,[ExpeditedFreight] - air shipment
|
Not Available
|
,[Quantity]
|
VBEP.WMENG
|
,[UOM]
|
VBAP.MEINS
|
2. Need to apply the groupings for removing duplicate records in the report. Those groups are as follows: VBAK.VBELN, VBAP.MATNR & VBEP.J_3ASIZE .
3. Need to write the filter conditions to get the data for ROC and B2B orders as below:
{VBAK.BSARK} IN ['ROC','B2B']
AND {VBAK.ERDAT} in (CurrentDate - 90) to CurrentDate
and {LIPS.POSNR} startswith '9'
AND {T151T.SPRAS} = 'E'
and {TVZBT.SPRAS} = 'E'
AND {TVV2T.SPRAS} = 'E'
4. Need to promote the report into BI Production after successful validation.
Issues
None